iT邦幫忙

3

[SQL Server] Excel匯入資料到SQL Server table

  • 分享至 

  • xImage
  •  

1.設定來源,目標
EXCEL 驅動選 Microsoft Excel
SQL Server 驅動通常都選SQL Server Native Client 11.0
*如果是2000選SQL Server Native Client 11.0會出現錯誤訊息
https://ithelp.ithome.com.tw/upload/images/20190523/20106764AMZVkMQySZ.png
所以2000以前,就選SQL Server Native Client 10.0

這次的筆記,選Microsoft OLE DB Provider for SQL Server也可以!

2.對應資料表.欄位
https://ithelp.ithome.com.tw/upload/images/20171113/20106764Yfw0U7W672.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764JrHcUzfR4N.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764FdMU92quYF.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764tOimalKXtW.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764OWeZ48g2G9.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764bo2XiUyVVQ.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764QzlH0zUaFd.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764yb8Z0GwWtk.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764ecu4t45hya.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764rGtsQrWkFC.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764ZJVruej2YY.pnghttps://ithelp.ithome.com.tw/upload/images/20171113/20106764aOupiIYRz9.png

*如果來源是記事本
https://ithelp.ithome.com.tw/upload/images/20190212/20106764AGXjWGbxIC.png


圖片
  直播研討會
圖片
{{ item.channelVendor }} {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

1 則留言

我要留言

立即登入留言